Skip to main content

UntypedSqlExpressionProxy<T>

Assembly: ServiceStack.OrmLite.dll​
View Source​
Declaration
public class UntypedSqlExpressionProxy<T> : object, IUntypedSqlExpression, ISqlExpression

Properties​

TableAlias​

View Source​
Declaration
public string TableAlias { get; set; }

PrefixFieldWithTableName​

View Source​
Declaration
public bool PrefixFieldWithTableName { get; set; }

WhereStatementWithoutWhereString​

View Source​
Declaration
public bool WhereStatementWithoutWhereString { get; set; }

DialectProvider​

View Source​
Declaration
public IOrmLiteDialectProvider DialectProvider { get; set; }

Params​

View Source​
Declaration
public List<IDbDataParameter> Params { get; set; }

SelectExpression​

View Source​
Declaration
public string SelectExpression { get; set; }

FromExpression​

View Source​
Declaration
public string FromExpression { get; set; }

BodyExpression​

View Source​
Declaration
public string BodyExpression { get; }

WhereExpression​

View Source​
Declaration
public string WhereExpression { get; set; }

GroupByExpression​

View Source​
Declaration
public string GroupByExpression { get; set; }

HavingExpression​

View Source​
Declaration
public string HavingExpression { get; set; }

OrderByExpression​

View Source​
Declaration
public string OrderByExpression { get; set; }

Rows​

View Source​
Declaration
public int? Rows { get; set; }

Offset​

View Source​
Declaration
public int? Offset { get; set; }

UpdateFields​

View Source​
Declaration
public List<string> UpdateFields { get; set; }

InsertFields​

View Source​
Declaration
public List<string> InsertFields { get; set; }

ModelDef​

View Source​
Declaration
public ModelDefinition ModelDef { get; }

Methods​

Clone()​

View Source​
Declaration
public IUntypedSqlExpression Clone()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Select()​

View Source​
Declaration
public IUntypedSqlExpression Select()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Select(String)​

View Source​
Declaration
public IUntypedSqlExpression Select(string selectExpression)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringselectExpression

UnsafeSelect(String)​

View Source​
Declaration
public IUntypedSqlExpression UnsafeSelect(string rawSelect)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringrawSelect

Select<Table1, Table2>(Expression<Func<Table1, Table2, Object>>)​

View Source​
Declaration
public IUntypedSqlExpression Select<Table1, Table2>(Expression<Func<Table1, Table2, object>> fields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table1>,<Table2>,System.Object>>fields
Type Parameters​
  • Table1
  • Table2

Select<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, Object>>)​

View Source​
Declaration
public IUntypedSqlExpression Select<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, object>> fields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table1>,<Table2>,<Table3>,System.Object>>fields
Type Parameters​
  • Table1
  • Table2
  • Table3

SelectDistinct<Table1, Table2>(Expression<Func<Table1, Table2, Object>>)​

View Source​
Declaration
public IUntypedSqlExpression SelectDistinct<Table1, Table2>(Expression<Func<Table1, Table2, object>> fields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table1>,<Table2>,System.Object>>fields
Type Parameters​
  • Table1
  • Table2

SelectDistinct<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, Object>>)​

View Source​
Declaration
public IUntypedSqlExpression SelectDistinct<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, object>> fields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table1>,<Table2>,<Table3>,System.Object>>fields
Type Parameters​
  • Table1
  • Table2
  • Table3

SelectDistinct()​

View Source​
Declaration
public IUntypedSqlExpression SelectDistinct()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

From(String)​

View Source​
Declaration
public IUntypedSqlExpression From(string tables)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Stringtables

UnsafeFrom(String)​

View Source​
Declaration
public IUntypedSqlExpression UnsafeFrom(string rawFrom)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringrawFrom

Where()​

View Source​
Declaration
public IUntypedSqlExpression Where()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

UnsafeWhere(String, Object[])​

View Source​
Declaration
public IUntypedSqlExpression UnsafeWhere(string rawSql, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringrawSql
System.Object[]filterParams

Ensure(String, Object[])​

View Source​
Declaration
public IUntypedSqlExpression Ensure(string sqlFilter, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringsqlFilter
System.Object[]filterParams

Where(String, Object[])​

View Source​
Declaration
public IUntypedSqlExpression Where(string sqlFilter, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringsqlFilter
System.Object[]filterParams

UnsafeAnd(String, Object[])​

View Source​
Declaration
public IUntypedSqlExpression UnsafeAnd(string rawSql, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringrawSql
System.Object[]filterParams

And(String, Object[])​

View Source​
Declaration
public IUntypedSqlExpression And(string sqlFilter, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringsqlFilter
System.Object[]filterParams

UnsafeOr(String, Object[])​

View Source​
Declaration
public IUntypedSqlExpression UnsafeOr(string rawSql, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringrawSql
System.Object[]filterParams

Or(String, Object[])​

View Source​
Declaration
public IUntypedSqlExpression Or(string sqlFilter, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringsqlFilter
System.Object[]filterParams

AddCondition(String, String, Object[])​

View Source​
Declaration
public IUntypedSqlExpression AddCondition(string condition, string sqlFilter, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Stringcondition
System.StringsqlFilter
System.Object[]filterParams

GroupBy()​

View Source​
Declaration
public IUntypedSqlExpression GroupBy()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

GroupBy(String)​

View Source​
Declaration
public IUntypedSqlExpression GroupBy(string groupBy)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringgroupBy

Having()​

View Source​
Declaration
public IUntypedSqlExpression Having()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Having(String, Object[])​

View Source​
Declaration
public IUntypedSqlExpression Having(string sqlFilter, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringsqlFilter
System.Object[]filterParams

OrderBy()​

View Source​
Declaration
public IUntypedSqlExpression OrderBy()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

OrderBy(String)​

View Source​
Declaration
public IUntypedSqlExpression OrderBy(string orderBy)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringorderBy

GetModelDefinition(FieldDefinition)​

View Source​
Declaration
public ModelDefinition GetModelDefinition(FieldDefinition fieldDef)
Returns​

ServiceStack.OrmLite.ModelDefinition

Parameters​
TypeName
ServiceStack.OrmLite.FieldDefinitionfieldDef

OrderByFields(FieldDefinition[])​

View Source​
Declaration
public IUntypedSqlExpression OrderByFields(params FieldDefinition[] fields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
ServiceStack.OrmLite.FieldDefinition[]fields

OrderByFieldsDescending(FieldDefinition[])​

View Source​
Declaration
public IUntypedSqlExpression OrderByFieldsDescending(params FieldDefinition[] fields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
ServiceStack.OrmLite.FieldDefinition[]fields

OrderByFields(String[])​

View Source​
Declaration
public IUntypedSqlExpression OrderByFields(params string[] fieldNames)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.String[]fieldNames

OrderByFieldsDescending(String[])​

View Source​
Declaration
public IUntypedSqlExpression OrderByFieldsDescending(params string[] fieldNames)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.String[]fieldNames

OrderBy<Table>(Expression<Func<Table, Object>>)​

View Source​
Declaration
public IUntypedSqlExpression OrderBy<Table>(Expression<Func<Table, object>> keySelector)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table>,System.Object>>keySelector
Type Parameters​
  • Table

ThenBy(String)​

View Source​
Declaration
public IUntypedSqlExpression ThenBy(string orderBy)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringorderBy

ThenBy<Table>(Expression<Func<Table, Object>>)​

View Source​
Declaration
public IUntypedSqlExpression ThenBy<Table>(Expression<Func<Table, object>> keySelector)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table>,System.Object>>keySelector
Type Parameters​
  • Table

OrderByDescending<Table>(Expression<Func<Table, Object>>)​

View Source​
Declaration
public IUntypedSqlExpression OrderByDescending<Table>(Expression<Func<Table, object>> keySelector)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table>,System.Object>>keySelector
Type Parameters​
  • Table

OrderByDescending(String)​

View Source​
Declaration
public IUntypedSqlExpression OrderByDescending(string orderBy)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringorderBy

ThenByDescending(String)​

View Source​
Declaration
public IUntypedSqlExpression ThenByDescending(string orderBy)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringorderBy

ThenByDescending<Table>(Expression<Func<Table, Object>>)​

View Source​
Declaration
public IUntypedSqlExpression ThenByDescending<Table>(Expression<Func<Table, object>> keySelector)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table>,System.Object>>keySelector
Type Parameters​
  • Table

Skip(Nullable<Int32>)​

View Source​
Declaration
public IUntypedSqlExpression Skip(int? skip = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Nullable<System.Int32>skip

Take(Nullable<Int32>)​

View Source​
Declaration
public IUntypedSqlExpression Take(int? take = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Nullable<System.Int32>take

Limit(Int32, Int32)​

View Source​
Declaration
public IUntypedSqlExpression Limit(int skip, int rows)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Int32skip
System.Int32rows

Limit(Nullable<Int32>, Nullable<Int32>)​

View Source​
Declaration
public IUntypedSqlExpression Limit(int? skip, int? rows)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Nullable<System.Int32>skip
System.Nullable<System.Int32>rows

Limit(Int32)​

View Source​
Declaration
public IUntypedSqlExpression Limit(int rows)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Int32rows

Limit()​

View Source​
Declaration
public IUntypedSqlExpression Limit()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

ClearLimits()​

View Source​
Declaration
public IUntypedSqlExpression ClearLimits()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Update(List<String>)​

View Source​
Declaration
public IUntypedSqlExpression Update(List<string> updateFields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
List<System.String>updateFields

Update()​

View Source​
Declaration
public IUntypedSqlExpression Update()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Insert(List<String>)​

View Source​
Declaration
public IUntypedSqlExpression Insert(List<string> insertFields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
List<System.String>insertFields

Insert()​

View Source​
Declaration
public IUntypedSqlExpression Insert()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

CreateParam(String, Object, ParameterDirection, Nullable<DbType>)​

View Source​
Declaration
public IDbDataParameter CreateParam(string name, object value = null, ParameterDirection direction = null, DbType? dbType = null)
Returns​

IDbDataParameter

Parameters​
TypeName
System.Stringname
System.Objectvalue
ParameterDirectiondirection
System.Nullable<DbType>dbType

Join<Source, Target>(Expression<Func<Source, Target, Boolean>>)​

View Source​
Declaration
public IUntypedSqlExpression Join<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>joinExpr
Type Parameters​
  • Source
  • Target

Join(Type, Type, Expression)​

View Source​
Declaration
public IUntypedSqlExpression Join(Type sourceType, Type targetType, Expression joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
TypesourceType
TypetargetType
ExpressionjoinExpr

LeftJoin<Source, Target>(Expression<Func<Source, Target, Boolean>>)​

View Source​
Declaration
public IUntypedSqlExpression LeftJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>joinExpr
Type Parameters​
  • Source
  • Target

LeftJoin(Type, Type, Expression)​

View Source​
Declaration
public IUntypedSqlExpression LeftJoin(Type sourceType, Type targetType, Expression joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
TypesourceType
TypetargetType
ExpressionjoinExpr

RightJoin<Source, Target>(Expression<Func<Source, Target, Boolean>>)​

View Source​
Declaration
public IUntypedSqlExpression RightJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>joinExpr
Type Parameters​
  • Source
  • Target

FullJoin<Source, Target>(Expression<Func<Source, Target, Boolean>>)​

View Source​
Declaration
public IUntypedSqlExpression FullJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>joinExpr
Type Parameters​
  • Source
  • Target

CrossJoin<Source, Target>(Expression<Func<Source, Target, Boolean>>)​

View Source​
Declaration
public IUntypedSqlExpression CrossJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>joinExpr
Type Parameters​
  • Source
  • Target

CustomJoin(String)​

View Source​
Declaration
public IUntypedSqlExpression CustomJoin(string joinString)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringjoinString

Where<Target>(Expression<Func<Target, Boolean>>)​

View Source​
Declaration
public IUntypedSqlExpression Where<Target>(Expression<Func<Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Target>,System.Boolean>>predicate
Type Parameters​
  • Target

Ensure<Target>(Expression<Func<Target, Boolean>>)​

View Source​
Declaration
public IUntypedSqlExpression Ensure<Target>(Expression<Func<Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Target>,System.Boolean>>predicate
Type Parameters​
  • Target

Where<Source, Target>(Expression<Func<Source, Target, Boolean>>)​

View Source​
Declaration
public IUntypedSqlExpression Where<Source, Target>(Expression<Func<Source, Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>predicate
Type Parameters​
  • Source
  • Target

Ensure<Source, Target>(Expression<Func<Source, Target, Boolean>>)​

View Source​
Declaration
public IUntypedSqlExpression Ensure<Source, Target>(Expression<Func<Source, Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>predicate
Type Parameters​
  • Source
  • Target

And<Target>(Expression<Func<Target, Boolean>>)​

View Source​
Declaration
public IUntypedSqlExpression And<Target>(Expression<Func<Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Target>,System.Boolean>>predicate
Type Parameters​
  • Target

And<Source, Target>(Expression<Func<Source, Target, Boolean>>)​

View Source​
Declaration
public IUntypedSqlExpression And<Source, Target>(Expression<Func<Source, Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>predicate
Type Parameters​
  • Source
  • Target

Or<Target>(Expression<Func<Target, Boolean>>)​

View Source​
Declaration
public IUntypedSqlExpression Or<Target>(Expression<Func<Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Target>,System.Boolean>>predicate
Type Parameters​
  • Target

Or<Source, Target>(Expression<Func<Source, Target, Boolean>>)​

View Source​
Declaration
public IUntypedSqlExpression Or<Source, Target>(Expression<Func<Source, Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>predicate
Type Parameters​
  • Source
  • Target

SqlTable(ModelDefinition)​

View Source​
Declaration
public string SqlTable(ModelDefinition modelDef)
Returns​

System.String

Parameters​
TypeName
ServiceStack.OrmLite.ModelDefinitionmodelDef

SqlColumn(String)​

View Source​
Declaration
public string SqlColumn(string columnName)
Returns​

System.String

Parameters​
TypeName
System.StringcolumnName

ToDeleteRowStatement()​

View Source​
Declaration
public string ToDeleteRowStatement()
Returns​

System.String

ToSelectStatement()​

View Source​
Declaration
public string ToSelectStatement()
Returns​

System.String

ToSelectStatement(QueryType)​

View Source​
Declaration
public string ToSelectStatement(QueryType forType)
Returns​

System.String

Parameters​
TypeName
ServiceStack.OrmLite.QueryTypeforType

ToCountStatement()​

View Source​
Declaration
public string ToCountStatement()
Returns​

System.String

GetAllFields()​

View Source​
Declaration
public IList<string> GetAllFields()
Returns​

IList<System.String>

FirstMatchingField(String)​

View Source​
Declaration
public Tuple<ModelDefinition, FieldDefinition> FirstMatchingField(string fieldName)
Returns​

Tuple<ServiceStack.OrmLite.ModelDefinition,ServiceStack.OrmLite.FieldDefinition>

Parameters​
TypeName
System.StringfieldName

SelectInto<TModel>()​

View Source​
Declaration
public string SelectInto<TModel>()
Returns​

System.String

Type Parameters​
  • TModel

SelectInto<TModel>(QueryType)​

View Source​
Declaration
public string SelectInto<TModel>(QueryType queryType)
Returns​

System.String

Parameters​
TypeName
ServiceStack.OrmLite.QueryTypequeryType
Type Parameters​
  • TModel

Implements​